package com.easy.bean;

import lombok.Data;

/*
字段名	类型	说明	约束
detail_id	INT	详情ID（主键）	PRIMARY KEY, AUTO_INCREMENT
order_id	INT	关联订单ID	FOREIGN KEY REFERENCES orders(order_id)
fruit_id	INT	水果ID	FOREIGN KEY REFERENCES fruit(fruit_id)
quantity	DECIMAL(8,2)	购买数量(公斤)	NOT NULL
unit_price	DECIMAL(10,2)	成交单价	NOT NULL
donation_ratio	DECIMAL(3,2)	捐赠比例(0.05表示5%)	DEFAULT 0.05
 */
@Data
public class Order_detail {
    private Integer detail_id;
    private Integer order_id;
    private Integer fruit_id;
    private Double quantity;
    private Double unit_price;
    private Double donation_ratio;
    private Byte isdel;
    private String fruit_name;
    private String order_no;


}
